SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 701948 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 701948 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011148,399651,34913,653466,618801,728410,55220,942026,426703,197653,818493,510471,455608,152096,266870,548230,804623,1011897,82038,43060,150305,422754,546040,846567,944260,74519,305839,628146,486775,401869,362285,24580,661285,939532,105289,918028,782157,54392,990504,879872,979817,490974,682241,695866,307022,447047,995196,485133,758770,594636,576187,833795,926122,49169,205398,142548,516742,215004,860638,730423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 701948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 701948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]