SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428059 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428059 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770843,437694,654539,803862,830287,316496,492009,754537,402647,757097,133276,600142,87389,177976,874006,145132,6297,241201,163446,603106,678960,803635,49804,76374,900140,1030164,569556,839179,240423,989846,146075,897353,980533,631949,165559,568453,348753,947857,422586,113304,208283,107282,45410,958118,861546,956643,998785,184273,828964,1046789,639442,772838,550338,165950,438017,444987,455974,294787,474255,547747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002457s ]