SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410996 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410996 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492434,957817,246147,1019650,905925,75554,428231,433755,460885,901651,746129,319828,687350,251591,363530,757673,75940,833512,20778,140065,690901,238667,846177,296434,193423,805617,932419,390377,966258,406648,243647,119648,578376,205609,235846,378340,5771,282563,1011283,332178,211231,608980,990258,206986,388980,344257,1003081,898886,229413,772640,150017,141640,209805,227110,879292,103365,52420,875884,830617,336991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]