SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468516 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468516 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436722,445281,344047,107927,524485,37881,759218,505965,534169,989910,140542,87020,967924,503021,528963,949256,600316,1007715,826763,352945,399041,360851,387361,986045,906102,858276,511127,163906,975068,86740,965614,629865,722861,273678,293750,666164,904657,243455,865108,150345,777921,551912,724071,197948,322027,510234,1013440,1046537,106117,46659,474351,105710,513336,647687,335920,767135,679877,796793,186744,104545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]