SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402350 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402350 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410494,718926,886577,529762,191347,535031,628590,534127,402559,214345,427017,1036539,501123,144240,982812,944428,291420,720455,474903,429030,513171,400692,162361,417011,785701,504848,363718,706912,856245,684483,460041,307778,979765,306218,795835,982764,1036620,953194,245853,674914,598937,30556,627212,152700,142508,586281,24448,755183,346646,280986,809990,849491,442688,515726,927692,772779,602957,228740,87822,25443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402350 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402350 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]