SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502723 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502723 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332289,975983,201705,506559,502739,807182,988618,780360,1405,425473,477768,994314,337453,1046424,307899,29034,583039,198807,1035123,660609,530234,158041,832640,56979,201332,811904,599175,835173,605828,536176,705217,211621,959906,598550,805267,873482,555984,159876,377057,432557,162818,1039534,875694,737593,361307,55678,861511,914752,750889,74244,888192,503961,143770,881118,121793,695795,1042791,351100,34282,419333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]