SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681876 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681876 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407277,17214,619479,672655,648321,301710,679747,481927,535666,150095,931790,303210,304245,152927,680173,760532,401680,585131,77993,439843,717710,688017,411432,381793,307163,488355,663338,327148,502922,1020384,162053,451859,160505,329090,681890,117018,70180,707881,631639,648833,108850,421088,761968,165644,498336,201845,28789,507383,235809,885500,273428,169894,232720,263077,856249,603026,473183,479426,27970,537494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]