SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511106 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511106 [ RunTime:0.002241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160211,872606,1025639,555608,52448,534247,467413,195024,688295,925519,711258,702444,1018741,605986,619351,825636,179394,124456,190534,552885,559077,390285,123107,640664,814280,913804,912393,108026,197591,333555,825055,508138,49315,127341,786878,75212,696943,48345,584329,586484,501303,710637,535485,308883,377167,534832,48931,300896,201717,324204,1015821,984894,491649,946762,586552,49927,624593,184599,198996,178746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002694s ]