SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473728 LIMIT 1 [ RunTime:0.001430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473728 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047745,345336,839516,519196,789136,540069,906656,606188,539095,363316,35314,475562,650161,516700,886833,1034560,559600,365158,405486,320831,888395,505181,386564,252981,505865,884341,124629,193476,401926,497576,775838,481611,492673,159422,734829,789575,829859,884668,737137,740753,875003,756887,203080,336457,122813,370904,633142,817162,313229,565841,925682,903183,28929,707735,761149,998113,198454,695995,407593,579927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004495s ]