SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205650 LIMIT 1 [ RunTime:0.000763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205650 [ RunTime:0.004178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851864,531061,487914,760587,271941,171072,447581,189167,774630,36274,970699,417059,922586,419121,326082,601140,684726,487943,863119,621246,1010380,878972,767757,910977,832984,965078,929384,475499,72456,672085,927949,767935,9484,700719,175007,241063,483069,345200,657767,562664,69025,857891,58056,137673,612004,159190,1008686,18670,320966,398388,97718,910322,956508,537829,227165,11345,949635,449327,300596,454424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]