SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 857315 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 857315 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417421,196312,733578,591054,369700,77133,1025600,733920,726184,81422,464650,842864,53382,640593,38755,468057,446059,480761,765873,643641,431835,642108,9249,284839,486577,20868,525191,193635,942689,491331,688353,284179,783041,430999,704035,651427,671649,744020,222734,256148,876866,104675,473395,89067,429158,717384,227010,369069,1003325,388567,432436,500003,672938,100090,80723,610484,334247,527194,311792,283326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 857315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 857315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]