SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425683 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425683 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849749,37674,734306,770125,171292,621287,43529,1019901,101141,436618,983151,497433,352959,507535,974820,150770,647320,829793,120250,895933,841292,195361,811927,15659,210963,759725,412360,750005,498020,52792,361233,621744,474981,883224,195487,512533,163409,546340,914240,6564,726225,843284,738355,921206,108676,705335,330260,299133,623050,460896,353307,923595,593123,194162,178027,492140,119052,344935,744214,177638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]