SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804209 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804209 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826123,976628,149838,335470,34467,1031068,782826,857014,610547,535755,120141,310703,987727,544984,390414,544839,548123,239716,746058,885924,116223,380986,406854,595968,409415,934533,962732,922837,322432,781634,242386,980961,200823,814800,238684,910899,878941,494795,394814,998846,929966,413254,414466,784120,254226,161681,486789,891302,967706,470586,718200,816643,992174,731498,897777,416030,1013769,388016,834738,384144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]