SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001996s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016436 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016436 [ RunTime:0.005435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035033,920144,128278,272374,1048234,776896,837674,558323,200086,650482,50663,992370,402263,699463,67427,708510,477594,397325,346232,1009350,223054,339492,614089,873536,568381,858002,69058,219172,503986,529663,339894,800482,362779,213306,1007475,894751,770866,545743,406766,447275,813087,89655,699290,972805,880779,504062,626954,239882,639384,806222,196055,803612,946663,557650,283665,887943,984421,196436,793190,517712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001929s ]