SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10116 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10116 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263220,1000182,627039,762767,91280,58170,389531,1045306,325443,606302,16698,413754,777364,297312,880367,949176,100658,797417,888334,950595,23979,872856,839541,1019047,795817,114487,801133,78857,75327,193345,502258,89380,199194,1007112,861113,345368,190462,812144,310733,745335,17030,588374,523982,480839,204465,362839,289218,444347,727464,812530,336467,1045387,393326,691681,428132,316675,231099,591018,3046,595124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]