SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367438 LIMIT 1 [ RunTime:0.000691s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367438 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893462,1038875,866281,727463,116643,145226,859123,751899,945660,80234,116850,672864,909917,161970,114797,57203,440277,741040,953026,357804,712099,756349,465033,43536,686415,656947,710624,870707,78340,803455,277672,326363,506906,285794,200918,1017980,619206,303589,80732,772474,173909,815933,990530,291694,439842,934283,956474,894405,496857,65974,524070,71641,37523,218508,635343,364727,495284,423883,1027187,169840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]