SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516083 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516083 [ RunTime:0.001373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043211,575555,964654,247888,245203,531571,386528,393202,866434,591875,812825,168478,937336,182753,81574,3572,997875,500547,663000,222387,215934,491727,92669,796788,1033923,207785,683488,141690,723633,631612,838830,496402,494973,55941,745703,962739,431877,542322,326641,674015,140580,27669,118549,309110,482351,386750,787144,77150,1000291,224224,80791,941022,979254,953890,315275,257974,89313,205657,942926,953940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]