SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51450 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51450 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497649,561779,122146,338311,1018952,16898,532857,452899,7956,625763,560128,843043,1041630,863757,145739,959619,103281,550723,299021,130289,174676,59019,1017875,897724,984363,421800,932076,87217,898018,600596,674925,955711,150283,924071,787637,956940,754726,102915,1043211,571149,501395,880060,162043,115212,429033,280873,84491,416753,809258,530013,824246,641504,296447,643587,657356,388720,186402,335732,959126,217675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]