SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293391 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293391 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377529,105018,777835,273116,76849,142906,21783,895620,617497,796589,392483,217735,804652,183333,540195,13614,529769,72227,72972,83346,541612,288580,534443,872147,224905,530260,502627,253312,424937,512413,758593,790366,418729,137939,754032,853556,462670,519002,991935,761511,325282,967529,546609,618343,15418,252724,609734,97100,882359,456268,779492,285952,527870,583305,537521,53385,443637,536275,870729,396689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]