SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414950 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414950 [ RunTime:0.005823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168113,590461,683887,1008103,113876,301450,632257,619218,463165,345393,985681,729152,254406,89488,20753,1035111,1048176,367173,70004,91043,1038361,909735,751487,610220,74614,69985,692343,640984,2051,293452,915037,45073,47262,106635,527770,110199,587771,546723,848514,3652,832095,404693,87667,173263,329128,214029,212250,379718,996982,11512,455926,481881,371934,180025,551213,512748,252521,786408,521758,656512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]