SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55030 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55030 [ RunTime:0.002711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43232,912093,1045781,1030738,348022,596283,392081,974248,14858,382918,334574,235632,545673,876476,534288,293430,199034,278598,150840,93066,352675,844283,224856,275800,753760,9909,253723,453280,493630,338225,811059,642956,920249,302710,707635,734537,909707,159546,837561,142737,213301,191724,471204,450726,522944,502233,409782,88092,922524,701008,812109,350695,390988,56264,677891,171302,48223,554833,7654,811732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001643s ]