SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426049 LIMIT 1 [ RunTime:0.000740s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426049 [ RunTime:0.003526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212568,954463,126186,1031480,700545,1027310,205355,504242,1012409,940261,836207,52491,355427,931180,658273,102283,878334,905513,220413,791902,664244,136310,931732,294478,652106,33111,704712,223908,268326,239229,362745,231663,160621,901855,494847,353338,631034,703931,467382,52500,1003088,48606,69329,250016,172531,460865,450495,412776,871609,770012,297654,168988,10248,1043962,380774,213125,384279,120977,788375,265008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]