SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475250 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475250 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463942,925045,542485,225336,74808,380828,230184,959958,801533,296163,903077,601291,235484,491523,920041,615663,148191,23632,29416,655336,633320,301405,521912,485339,747592,127354,98796,909956,912941,164268,477697,511967,954459,632396,448943,149641,545267,846271,499736,169633,1032371,415403,987270,194442,723473,236637,806184,28609,56265,995662,662303,158819,910243,250866,693964,123443,372301,446467,1048122,645080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]