SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002010s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200190 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200190 [ RunTime:0.002291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367596,564810,1044337,84957,280841,559519,82431,773449,269436,129714,324280,359351,383561,855957,720837,207573,716078,331331,549255,993995,506703,409208,647537,235444,693463,814533,474448,800637,834215,235215,379209,818600,559271,240370,859737,588135,229300,757264,28980,375333,44675,188504,546042,700663,63878,384856,652611,397043,420861,282129,962570,514523,923670,744262,433200,234131,191588,92964,141152,624406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]