SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419019 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419019 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605500,917261,311831,743730,416856,850879,879611,824248,376461,607580,311921,626127,693215,468538,984989,989365,2476,1037629,453067,911365,924885,367314,613932,404201,700480,911374,178190,501116,323465,1029657,705269,492770,37839,716600,712817,999149,415562,1019261,950115,306531,473450,745726,982490,496855,638056,731084,1038117,136170,725210,23247,267345,617661,882635,87462,470697,414860,572516,470146,414813,292253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]