SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340190 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340190 [ RunTime:0.002016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453064,469882,759393,918139,33001,416652,734052,993999,439794,663714,503386,327911,960992,632518,288524,55941,788747,758567,537119,197052,600024,1041611,149679,7923,446600,54157,424955,782761,40788,545093,5629,413321,687550,734185,550035,144827,559860,224446,596557,941493,887775,689910,575161,331259,254505,450043,128705,686313,143572,212347,806975,915051,687928,488889,85691,212430,40884,679745,622149,654597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]