SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804102 LIMIT 1 [ RunTime:0.000546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804102 [ RunTime:0.002519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180085,822659,889492,144107,830450,738804,568138,523956,333335,438774,473675,490320,391144,27381,121895,933187,467753,183408,391580,439657,159152,700058,369703,253283,718954,625309,266024,100296,742560,322088,302295,457274,580719,30999,660851,501021,884587,913176,152072,273577,972246,5007,625743,877155,759467,300480,890645,552904,1016145,552039,512471,859249,493208,131289,1032659,37537,449512,577881,913099,300187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]