SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809341 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809341 [ RunTime:0.002453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020397,35127,726258,523934,391017,277440,339222,146174,584617,511566,1043003,239447,186432,926363,741025,477698,829502,252858,33196,970702,124554,808492,522741,102187,856363,983674,665069,876179,1009839,917559,950065,18571,124598,781201,881130,220273,318707,1014810,83172,610067,785403,915851,226886,311569,210889,505966,925078,78532,791915,801901,872185,516575,628795,300516,427133,711804,201966,141174,494599,914520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]