SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54129 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54129 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633188,378535,791026,602995,161543,12476,401089,984531,960158,567955,88312,609926,960599,951225,1022477,235650,256427,629871,291004,57443,232681,169691,1027995,133615,298078,106238,371939,830667,593968,339256,724311,732735,718692,165549,162479,556517,126116,529323,747533,384460,453912,271252,930776,129001,977673,472622,498348,298022,431844,507246,715733,683957,539669,270505,615099,589861,433053,416532,778693,484901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54129 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54129 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]