SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5331 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5331 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945139,115383,897622,950191,897412,640908,206565,573221,160017,218386,337083,143150,810293,777090,15270,384234,585112,1000326,637729,70230,890825,415908,553558,1022040,301324,648618,210576,350757,20356,15504,802025,350943,86657,449402,411407,567948,155261,328962,203434,1040283,200168,507790,554178,648423,721800,717111,795176,825127,571237,143092,677972,177756,706575,672577,575373,252991,803351,331161,970615,833671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]