SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54383 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54383 [ RunTime:0.003684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783188,706973,406341,978900,164094,432757,947826,492896,228531,153961,809390,551169,318138,165435,184407,740134,893088,634636,527554,848217,572797,318213,98957,198798,966171,570561,22011,827222,631685,853697,270165,514874,208741,474741,243437,208257,133923,779081,493829,854545,671021,75101,660808,545082,834110,719260,205562,418165,945747,184420,383710,93895,772382,425901,751588,897048,133031,100571,300726,12055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002687s ]