SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481455 LIMIT 1 [ RunTime:0.007137s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481455 [ RunTime:0.003602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138183,887168,429770,13635,1000282,112990,467121,667489,17558,270183,968951,848492,786190,374954,643278,5298,688043,1043480,691793,677894,1004671,42090,726661,390542,335235,834091,373820,691504,714360,755086,478160,902672,163727,687988,423036,6940,869527,558331,453452,577629,865034,665494,161395,838145,251235,902513,1024562,728686,163797,164915,962590,580019,239550,737737,708521,570399,1013915,921758,376950,759258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001352s ]