SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118153 LIMIT 1 [ RunTime:0.000667s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118153 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437019,1022921,3269,798669,237187,390242,147620,1036421,578973,979379,441866,85811,721841,728197,406217,584622,281179,757680,920977,547965,311681,224444,324954,976106,768547,948240,972768,893237,663603,279110,129228,153783,991683,469337,548530,85530,594513,1011835,871702,851976,185089,550481,981638,712439,647293,690168,916643,235143,589117,364742,222733,345993,73620,517351,48271,482401,740918,849956,360730,309291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000970s ]