SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280540 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280540 [ RunTime:0.004381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374913,753436,402735,836679,549179,1039548,177819,46390,1043139,906376,315351,258133,740222,923248,770825,714857,994316,684196,499124,417406,485092,539598,755770,248814,440688,337265,884890,730323,485673,238877,653000,567764,293751,792433,543269,447946,670248,816725,147699,519251,727138,9311,1045706,79005,1039619,136517,578990,223283,63072,311838,249634,6011,82368,363928,100126,992728,303806,574383,847343,475714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]