SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294723 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294723 [ RunTime:0.002262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010288,564142,625246,506970,161986,834653,398915,736554,140631,671468,360740,365899,615199,479411,888791,291722,230444,946952,157211,78405,184943,777631,450098,21481,210294,549569,643975,5453,534578,338607,974309,408311,180556,148775,612048,456161,640582,125383,66650,170783,849543,153192,757987,586752,168138,120676,133753,869630,343054,91676,718270,758926,110347,105073,421508,551468,37914,537353,485318,200338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]