SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292380 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292380 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100091,86063,625559,607888,309554,190619,768881,949414,197073,1031061,199685,506293,435205,933613,180788,352390,655217,1023642,66645,652176,106769,896926,458899,180151,658868,359740,462549,363870,605244,467263,831330,255062,307165,928427,884494,929076,203629,739273,453493,890303,663283,156994,975954,252866,467958,751579,1024022,694131,881410,777602,564473,828886,403389,839513,338272,441216,263167,521975,65152,994507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]