SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594781 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594781 [ RunTime:0.002490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019096,220089,1038853,324109,210727,44541,721129,683933,937343,728987,641217,783368,51747,5384,274189,605281,762191,986100,594262,432866,518273,453501,225699,72434,882577,588776,909146,240430,748941,508585,798318,158635,1015297,941337,305093,745053,322163,648605,190296,917259,385366,762671,1043918,28722,956054,1007832,564619,450180,670310,206712,349810,463275,194530,237884,803974,870538,723932,721358,143225,320056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]