SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262620 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262620 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501923,56970,545360,153930,81221,766676,5454,84796,82091,649777,20830,642740,55280,738165,737738,938383,184290,264767,990759,768110,671130,172356,310684,168215,18101,754240,722012,217833,940278,116518,530088,298884,188519,85486,921129,864199,750981,76148,557572,494059,131294,79254,755712,711028,722770,981585,528668,897999,609512,991136,47976,348640,575848,627691,629714,678013,8439,504788,25677,1030476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]