SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281417 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281417 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046883,297952,660662,624634,12686,875893,844263,494080,671260,269882,695029,742918,106900,860128,436491,496312,635656,830343,779484,350046,753269,718023,622846,808438,871670,181667,882006,114317,412809,97357,105838,387708,579628,805116,568181,924726,225112,728121,62951,945423,1032761,970869,708106,678583,150225,984992,851023,452783,297945,39143,832115,908597,136,405025,355825,115908,721046,314125,883356,113316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]