SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901222 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901222 [ RunTime:0.002192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431665,125500,431802,709244,902592,744170,218152,75612,108014,1030890,449156,720086,991528,213628,294047,112576,730060,300671,608933,15222,202177,188434,283718,212284,339389,31131,966000,92634,204975,955905,853753,579660,1038072,288020,808572,108635,623276,829780,823168,709394,980839,589800,328150,381102,996368,546984,28461,639184,647467,961623,829837,254412,695772,483809,1006897,358445,838783,214077,475187,418035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]