SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552806 LIMIT 1 [ RunTime:0.000889s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552806 [ RunTime:0.005093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556013,103255,98738,893764,906765,596361,941988,871947,564561,45765,297584,290814,975723,797311,259654,97082,871892,209460,528061,296559,488775,134550,38614,616246,598515,662212,152778,398008,204456,892035,675071,867566,609826,1018787,493625,410858,132078,669988,650595,489692,271549,588816,831456,68631,126262,303005,413458,568489,764514,652027,981256,439091,834055,796195,490148,713769,912907,178968,294042,913637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001937s ]