SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001763s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429702 LIMIT 1 [ RunTime:0.002372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429702 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76443,904448,375447,595770,503635,637647,716575,837553,386644,366209,940902,425707,1018896,848554,207558,961434,851473,487061,781810,745512,840888,266137,931608,2923,437570,579593,649610,494250,642157,732847,319010,195373,920514,314510,212125,345085,278937,190242,848468,21530,420628,986093,392057,611553,489093,948764,852540,81224,364961,282017,796889,175728,851461,966192,230470,971279,510727,400993,135899,817513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]