SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97143 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97143 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655075,481652,300345,820101,196527,588772,936536,425514,1007389,223211,109405,538873,466378,997262,525161,35026,379674,37061,1011605,707469,740921,993527,354960,50962,632590,1024935,786586,370365,347590,319613,486999,235608,929184,312940,851652,557681,792895,158816,850195,719010,169902,910715,843194,21781,484729,63002,653260,117544,266484,829704,802925,501864,189058,171120,376565,965965,601023,860433,513930,781564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]