SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343805 LIMIT 1 [ RunTime:0.001137s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343805 [ RunTime:0.005337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921389,791007,338898,967636,26957,510708,354375,525648,149692,24494,52883,175419,389193,340180,542566,162830,134493,172585,892535,244106,199870,61942,927038,193849,327488,150859,497507,157771,850459,976865,686071,96315,914495,741171,971447,574723,322890,996082,505887,996628,61876,854309,683986,943432,460242,674920,356205,744951,472044,616560,391684,205717,1005548,899613,918747,976760,554516,579854,649993,930674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]