SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001667s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382540 LIMIT 1 [ RunTime:0.000785s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382540 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218070,13436,22992,578608,722196,423155,804387,630269,464671,572080,222747,555821,959735,249907,400223,117632,1044513,853825,193062,585234,132610,822613,627529,423643,980571,37542,42414,944611,1021289,770743,866388,615201,1033151,984364,342321,210442,683088,535445,970305,1006787,182835,38470,574379,710366,727626,390636,520088,381787,967455,787481,767745,76774,1011680,8311,801997,895694,145903,554735,791212,689338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]