SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048481 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048481 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558792,146621,809033,142764,647457,847537,699137,757042,626010,153656,913363,1047743,760874,438908,384336,642974,679181,26307,247623,673538,780335,176918,742401,901160,924787,950490,179040,128469,219867,503598,729386,233646,136550,247408,1031017,848226,215827,433880,630583,854881,1038971,78551,627774,481217,332303,1023231,256619,291311,105777,508552,493346,654634,605720,8844,292588,453283,582030,954222,138756,542323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]