SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003314 LIMIT 1 [ RunTime:0.000712s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003314 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765833,697901,917233,1044766,857321,311403,402350,697540,737420,88086,1002919,424730,830711,152294,726046,913626,1006353,272021,560706,659975,200090,574945,606861,330286,361167,265805,1013591,203572,717418,655057,168828,329771,49918,1022519,713249,262871,726070,763564,237863,716189,465473,272331,762142,989235,917010,50363,694319,204406,92043,235702,379106,212801,626676,332644,527866,939740,506393,520260,38456,661478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]