SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41422 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41422 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270757,121910,692411,255998,141092,478324,513595,919921,108961,117347,47348,987118,29790,103826,222823,702336,139499,793260,967155,973141,342984,766450,477865,579850,144549,322929,236215,292486,595731,193629,354819,776976,567281,740951,248159,703177,496693,204545,158137,97681,362306,1046166,984895,223318,197222,725463,228685,981818,1015778,233712,118916,393936,546927,491348,102156,341880,773208,216850,104082,126431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001240s ]