SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422161 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422161 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123416,1045720,372143,924580,456104,287230,526448,101191,790509,13747,310311,1036591,272925,552750,251611,144962,797341,260350,778601,901329,377019,799336,31145,955121,830163,275973,617199,595224,584861,691886,776587,117270,443882,386994,66977,1015429,991902,84165,861680,401961,115011,596154,498796,422249,825931,613767,122005,753811,458520,2987,997819,677599,999990,901523,10077,949091,181965,313621,422506,644813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]