SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459254 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459254 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78991,12845,611963,132908,659045,813177,658924,1046662,964117,495251,416947,119620,1042308,684411,431352,200421,944400,437246,176048,379833,357642,371898,260659,159520,498705,522061,131224,993113,578002,116591,328530,47012,828646,190641,918682,578086,597202,445139,535388,446433,722568,477963,537756,876766,776186,225844,341197,851623,971802,65558,506957,664926,960935,822518,1027550,180536,548251,144778,929697,24968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001658s ]