SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985612 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985612 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825621,132719,981018,293884,270178,511857,155766,206782,6241,841242,1002200,111866,753613,253377,944614,762108,102181,414554,308200,528716,459013,212309,860496,132027,677608,824412,284834,699717,573722,172502,998651,665532,345117,701891,579339,920793,1009344,524108,477214,600216,736304,635052,114973,787139,982021,730666,187648,1018722,178348,379339,133826,998401,11689,725877,143050,153106,1027750,170851,722112,781391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]