SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345113 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345113 [ RunTime:0.002679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601013,208332,377246,381423,68342,847978,417799,221638,739393,750063,1028544,18706,1019409,865671,358955,399687,748163,912195,883179,562925,1002152,362199,657320,618169,719329,649749,888927,425069,676960,120331,616597,525982,687467,700669,489531,29789,246666,236198,933527,338342,833364,325779,363284,834815,57033,134223,516108,168474,255773,404068,765534,1028986,214660,197580,343394,613551,137692,916110,474391,985892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]