SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549743 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549743 [ RunTime:0.005316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186166,509062,987402,381268,137498,529743,101604,830787,22432,1016171,980409,351945,293434,640067,62888,393221,1006766,184564,33201,36711,935632,1006859,504791,722420,662772,988898,635541,64063,803717,352925,187896,1033335,533567,977421,557561,284635,1024400,494189,871895,703862,614283,417544,582168,887248,816826,951173,821325,317815,457839,958237,152345,164862,150125,260759,762810,784468,743,1019723,116072,638664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]