SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349894 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349894 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834140,927347,117864,320086,979140,214139,706530,103492,832563,1012173,902099,361536,705724,912936,385960,486663,1011448,208956,870037,648851,199490,94603,855467,706270,88801,693463,785755,282056,589680,27002,445464,1035588,752278,996532,651841,840360,807944,253380,366618,692242,529393,744805,706918,937079,695097,872830,734837,1023951,170197,860925,194927,250101,641035,412676,907725,64517,514838,997214,82559,129557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]