SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413455 LIMIT 1 [ RunTime:0.001092s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413455 [ RunTime:0.004579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482888,770454,213093,268645,218871,586437,185881,864642,78644,656959,151359,2282,942432,988851,576521,841174,387925,189250,429940,159890,354725,460643,987003,264386,950056,194774,378981,755015,31701,129200,172274,786298,393813,79834,278994,810472,837870,678944,337708,695028,698473,973291,631401,308079,160671,102442,513596,894822,441728,90869,397379,244606,1039074,215127,685788,586489,522503,344485,244118,44349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]