SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563867 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563867 [ RunTime:0.002145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422845,162275,858712,1040137,448406,887756,464567,860944,352472,581726,61368,286788,224111,749597,392391,852026,598086,408375,390663,20289,989057,575986,665342,21006,637824,549425,698024,840561,930844,862464,291994,618088,108698,450076,250483,183077,879340,118311,1039509,31417,675965,191836,180789,733982,838098,110629,779137,335815,774643,855357,816911,857137,696311,799293,567041,885871,609909,196420,971068,721972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563867 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563867 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001345s ]