SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48301 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48301 [ RunTime:0.002427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981875,635377,506064,474545,228005,906272,515311,569633,419402,695005,328736,39358,263510,712717,569421,694552,16953,707519,916976,805503,966293,534474,422026,760033,1026389,30272,664575,706477,165499,39767,968925,958082,348179,389786,816672,198559,1021353,430634,127334,396064,132640,490574,149204,827088,557104,300908,962326,602067,831226,337183,517220,120684,451754,855293,127006,451929,839337,707049,553588,961768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]