SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349097 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349097 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209611,514204,481348,889749,1025251,943967,218069,150159,948763,514994,102338,751198,944530,1004973,866228,84274,285981,705236,817819,936328,764544,80773,579074,111687,410982,758569,892536,1000349,369715,191908,58820,595223,531650,550328,895056,685704,785639,238806,1022440,250224,516265,803937,790466,987300,177145,609245,677099,547697,9797,421969,597329,133798,522044,283731,904277,760693,600524,412755,25146,616303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]