SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014579 LIMIT 1 [ RunTime:0.002068s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014579 [ RunTime:0.004201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473147,349339,496011,541177,40814,674527,31031,3535,22712,163544,394969,402730,608684,1035797,311059,753801,155455,867706,740677,818551,794352,823244,42426,114852,889600,799081,236471,631606,1743,318991,731801,297607,874333,1042238,682618,196585,71844,927774,839687,214409,433784,681291,437008,1016276,294159,763538,89195,235843,383108,120727,155741,636541,717821,604490,988421,212039,681621,948439,991075,940024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014579 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014579 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]