SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347583 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347583 [ RunTime:0.002700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392660,180161,687879,137361,45688,672383,184348,108655,895352,713713,609063,1003750,143618,960259,266411,762026,376447,585959,386523,418979,232208,702074,980233,656805,100405,581508,56997,319060,390968,396080,546037,45441,854631,561928,61385,768064,719794,995235,959115,189277,471478,556864,254863,745017,1031920,874986,557402,1028469,1023681,977732,796901,155270,151256,337309,550395,596211,478859,739594,1031728,406787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]