SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340478 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340478 [ RunTime:0.003897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522240,120008,606274,886820,270370,953706,258199,1017427,167110,268660,886019,247263,733677,354506,75094,1000058,983154,82090,513206,452449,223381,341698,330418,955848,166139,544386,95429,104470,814955,625842,512564,508987,897574,515464,940270,380774,726841,485226,486095,1033079,662888,444521,926766,869631,77027,985819,968064,791192,934951,1035041,894750,883884,1048346,656053,29308,935024,59305,484031,5326,691928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]