SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199580 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199580 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362300,771812,136398,437780,777952,872025,654519,273460,494763,333318,415491,787973,866182,1028487,390277,356371,91494,106640,332585,165549,331627,692456,621298,327289,460898,316517,878759,316490,648568,507969,565717,677906,987245,688003,852580,81415,939642,134406,579423,744997,531077,468153,621849,153126,65330,812044,300048,151224,783374,385155,398658,620952,533211,541414,335695,994071,456510,495859,1003168,871491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]