SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 202812 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 202812 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359820,1048185,730405,4532,980565,722885,987535,535556,357868,1006584,753098,317557,441211,870249,563976,699829,738641,81229,360620,749271,451079,245912,421176,460174,395048,935814,382179,309081,102837,1025653,169821,400966,257818,38174,81515,34879,369909,923692,599263,365568,960986,528309,795693,411619,527618,604291,164947,568682,618647,976915,302290,855012,1020447,329452,670456,758034,539240,877451,40875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 202812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 202812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]