SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564032 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564032 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4752,626201,497000,817972,517320,280561,967394,562802,1040977,722574,442138,1017457,435341,356709,638746,827202,115620,360858,585663,37862,412456,909431,473789,97039,983607,752879,353381,390881,109857,827484,926258,476994,747555,742492,254528,457477,667793,191433,958064,684625,166526,299334,494042,124210,247774,928854,869015,656853,937157,817521,758999,7928,433105,541089,149116,552564,587560,457492,550156,165402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]